use dev1;

drop table dev1.feature_info;


create KEYSPACE dev1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};


create KEYSPACE livev1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};


use livev1;
create table feature_info (
feature_name text primary key,
description text,
owner text,
feature_hdfs_directory text,
src text,
src_hdfs_directory text);

ALTER TABLE feature_info
ADD tags set<text>;

use dev1;

insert into dev1.feature_info (feature_name, description) values ('test1', 'this is test enty');

insert into dev1.feature_info (feature_name, description, owner, feature_hdfs_directory, src, src_hdfs_directory)
values('test1fromdbeaver', 'this is test enty ', 'thient', '/data/path/to/test/entry/1', 'test1_original_src', '/data/path/to/src/1');

insert into dev1.feature_info (feature_name, description, owner)
values('dosomething1', 'ok fine', 'thient');

insert into dev1.feature_info (feature_name, description)
values('dosomething1', 'ok we edit but keep other');


use dev1;

insert into dev1.feature_info (feature_name, description)
values('dosomething2', 'create something2');


select * from dev1.feature_info;

use dev1;
select * from dev1.feature_info where feature_name='cat';

select * from dev1.feature_info;
